USE [vudu]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[ConsultarProfesorRol]
@ciProfesor varchar(30)
AS
BEGIN
	SET NOCOUNT ON;
	
	SELECT p.id_Cedula
	  FROM Profesor p
	 WHERE p.id_Cedula = @ciProfesor and p.estadoRol = 'Activo';
END;

SET ANSI_NULLS ON